/*
 Navicat MySQL Data Transfer

 Source Server         : maindatabase
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : webSec

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 08/04/2023 17:23:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for UserScore
-- ----------------------------
DROP TABLE IF EXISTS `UserScore`;
CREATE TABLE `UserScore` (
  `pid` int(2) NOT NULL,
  `uid` int(2) NOT NULL,
  `score` int(4) DEFAULT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of UserScore
-- ----------------------------
BEGIN;
INSERT INTO `UserScore` VALUES (1, 1, 10);
INSERT INTO `UserScore` VALUES (2, 2, 20);
INSERT INTO `UserScore` VALUES (3, 3, 30);
COMMIT;

-- ----------------------------
-- Table structure for UserScoreRecord
-- ----------------------------
DROP TABLE IF EXISTS `UserScoreRecord`;
CREATE TABLE `UserScoreRecord` (
  `sid` int(6) NOT NULL AUTO_INCREMENT,
  `uid` int(2) DEFAULT NULL,
  `kind` varchar(10) DEFAULT NULL,
  `score` int(4) DEFAULT NULL,
  `action` varchar(10) DEFAULT NULL,
  `date` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of UserScoreRecord
-- ----------------------------
BEGIN;
INSERT INTO `UserScoreRecord` VALUES (1, 1, 'scoreadd', 10, 'add', '23-04-07:07-17-25');
INSERT INTO `UserScoreRecord` VALUES (2, 1, 'scoreadd', 10, 'add', '23-04-07:07-32-31');
INSERT INTO `UserScoreRecord` VALUES (3, 1, 'scoreadd', 10, 'add', '23-04-07:07-32-35');
INSERT INTO `UserScoreRecord` VALUES (4, 1, 'shop', 10, 'reduce', '23-04-07:08-28-56');
INSERT INTO `UserScoreRecord` VALUES (5, 1, 'shop', 5, 'reduce', '23-04-07:08-30-37');
INSERT INTO `UserScoreRecord` VALUES (6, 1, 'shop', 5, 'reduce', '23-04-07:08-33-53');
INSERT INTO `UserScoreRecord` VALUES (7, 1, 'shop', 10, 'reduce', '23-04-07:08-34-51');
INSERT INTO `UserScoreRecord` VALUES (8, 1, 'scoreadd', 10, 'add', '23-04-07:08-35-24');
COMMIT;

-- ----------------------------
-- Table structure for UserShopRecord
-- ----------------------------
DROP TABLE IF EXISTS `UserShopRecord`;
CREATE TABLE `UserShopRecord` (
  `mid` int(6) NOT NULL AUTO_INCREMENT,
  `goods` varchar(255) DEFAULT NULL,
  `num` int(2) DEFAULT NULL,
  `price` int(4) DEFAULT NULL,
  `score` int(4) DEFAULT NULL,
  `date` varchar(20) DEFAULT NULL,
  `uid` int(2) DEFAULT NULL,
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of UserShopRecord
-- ----------------------------
BEGIN;
INSERT INTO `UserShopRecord` VALUES (1, 'pen', 2, 5, 10, '23-04-07:08-28-56', 1);
INSERT INTO `UserShopRecord` VALUES (2, 'pen', 1, 5, 5, '23-04-07:08-30-37', 1);
INSERT INTO `UserShopRecord` VALUES (3, 'pen', 1, 5, 5, '23-04-07:08-33-53', 1);
INSERT INTO `UserShopRecord` VALUES (4, 'apple', 1, 10, 10, '23-04-07:08-34-51', 1);
COMMIT;

-- ----------------------------
-- Table structure for message_board
-- ----------------------------
DROP TABLE IF EXISTS `message_board`;
CREATE TABLE `message_board` (
  `mid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `message` text,
  `browser` varchar(20) DEFAULT NULL,
  `os` varchar(20) DEFAULT NULL,
  `xforward_ip` char(15) DEFAULT NULL,
  `proxy_ip` char(15) DEFAULT NULL,
  `wlproxy_ip` char(15) DEFAULT NULL,
  `remoteaddr` varchar(15) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of message_board
-- ----------------------------
BEGIN;
INSERT INTO `message_board` VALUES (1, 'visa卡号', '5297747011073340，4737029071570700|01|2022|471', '测试', 'Windows', '0', '0', '0', '0', 1);
INSERT INTO `message_board` VALUES (2, '车牌号', '京A·10086，粤A·morec，鲁A· 13K6H', '测试', 'Windows', '0', '0', '0', '0', 1);
COMMIT;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(20) NOT NULL DEFAULT '',
  `age` int(11) DEFAULT NULL,
  `sex` tinyint(4) DEFAULT NULL,
  `mobile` char(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
INSERT INTO `student` VALUES (1, 'amdin', 22, 1, '17066876688');
INSERT INTO `student` VALUES (2, 'test', 18, 0, '18034753949');
INSERT INTO `student` VALUES (3, 'lmlsj', 16, 1, '13898764546');
INSERT INTO `student` VALUES (4, 'lm', 14, 1, '13056780865');
INSERT INTO `student` VALUES (5, 'sec', 20, 0, '17066876678');
INSERT INTO `student` VALUES (6, 'root', 22, 1, '18033066603');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL DEFAULT 'sysname',
  `password` varchar(40) NOT NULL DEFAULT 'abd@123',
  `rank` int(1) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'admin', 'abd@123', 0, 0);
INSERT INTO `user` VALUES (2, 'Iron Man', '123456', 2, 4);
INSERT INTO `user` VALUES (3, 'captial', '123qwe', 1, 2);
INSERT INTO `user` VALUES (4, 'eagle eye', '1qaz2wsx', 1, 3);
INSERT INTO `user` VALUES (5, 'lmlsj', 'abd@123', 2, 1);
INSERT INTO `user` VALUES (6, 'lm', 'plmnhytfx', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for userInfo
-- ----------------------------
DROP TABLE IF EXISTS `userInfo`;
CREATE TABLE `userInfo` (
  `id` int(3) NOT NULL,
  `name` varchar(40) NOT NULL,
  `passwd` varchar(80) NOT NULL,
  `school` varchar(200) NOT NULL,
  `address` varchar(255) NOT NULL,
  `perm` int(2) NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  `telephone` varchar(11) DEFAULT NULL,
  `skill` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of userInfo
-- ----------------------------
BEGIN;
INSERT INTO `userInfo` VALUES (1, 'test', 'admin123', 'Tsinghua University', 'Beijing', 2, 'qing@163.com', '17066878766', 'sing,dance,basketball');
INSERT INTO `userInfo` VALUES (2, 'lmlsj', 'qazxcde34', 'Peking University', 'Beijing', 4, 'stu@beida.com', '17088766678', 'write,computer,sleep');
INSERT INTO `userInfo` VALUES (3, 'admin', 'admin@123', 'Science and technology university', 'Guangdong', 100, 'admin@adminlm.com', '18030045678', 'program,security');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
